DDB
Basic and Crystal syntax.
Overloads
- DDB (cost, salvage, life, period)
- DDB (cost, salvage, life, period, factor)
Arguments
- cost is a Number or Currency that specifies the initial cost of the asset. The value is nonnegative and greater than or equal to salvage.
- salvage is a Number or Currency that specifies the value of the asset at the end of its useful life. The value is nonnegative.
- life is a positive Number that specifies the length of the useful life of the asset.
- period is a Number that specifies the period for which asset depreciation is calculated. The value is positive and less than or equal to life. The arguments life and period must have the same units.
- factor is an optional positive Number that specifies the rate at which the balance declines. If omitted, 2 (double-declining method) is assumed.
Returns
Number value
Action
DDB returns a Number specifying the depreciation of an asset for a specific time period, using the double-declining balance method or some other method as specified by the factor argument.
Examples
The following examples are applicable to both Basic and Crystal syntax:
Suppose a company purchases a fleet of cars for $500,000. The cars have a lifetime of 10 years and a salvage value of $60,000. They are depreciated using the double-declining method.
DDB (500000, 60000, 10, 1)
Returns 100000. The first year's depreciation is $100,000.
DDB (500000, 60000, 10, 4)
Returns 51200. The fourth year's depreciation is $51,200.
DDB (500000, 60000, 10, 10)
Returns 7108.864. The final year's depreciation is $7,108.86.
Comment
This function is designed to work like the Visual Basic function of the same name.